
/****** Object:  StoredProcedure [dbo].[Tecnology_R_ByProyect]    Script Date: 07/25/2012 23:53:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[Tecnology_R_Resource]
    @ResourceId INT
AS

	SET NOCOUNT ON;
	
	--Select con Filtros
	SELECT 
	    T.id,	    
	    T.nombre
	    FROM LineaTiempo LT
	 INNER JOIN TecnologiaRecurso TR ON LT.recursoId= TR.recursoId and LT.id= @ResourceId
	 INNER JOIN  Tecnologia  T ON T.id = TR.tecnologiaId
	 
	 
	SET NOCOUNT OFF;	
GO


